SELECT doc.docdesc, doc.updatedatetime, CONCAT( pro.last_name, '(',doc.doccreator,')') AS Uploaded_By, dem.last_name, dem.first_name,
CONCAT( "", "eChart", "" ) AS "eChart"
FROM document doc
LEFT JOIN ctl_document ctl ON doc.document_no = ctl.document_no
LEFT JOIN demographic dem ON ctl.module_id = dem.demographic_no
LEFT JOIN provider pro ON doc.doccreator = pro.provider_no
WHERE doc.updatedatetime BETWEEN ('{start_date} 00:00:00') and ('{finish_date} 23:59:59')
AND doc.doccreator = IF( '{provider}' = 'ALL', doc.doccreator , IF( '{provider}' = 'NONE', '', '{provider}' ))
AND LOCATE( '{searchfor}', doc.docdesc ) > 0
;
( SELECT provider_no, CONCAT(last_name,',',first_name,'(',provider_no,')') AS name
FROM provider )
UNION
( SELECT 'ALL', ' All providers' )
UNION
( SELECT 'NONE', ' No provider' )
ORDER BY name ;